<?php 
	require_once "config/constantes.php";
	require_once "config/config.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0014)about:internet -->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.........::::::::: caRHmo - Desenvolvimento Humano e Empresarial :::::::::.........</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<?php 
	require_once "config/css.ini";
	require_once "config/js.ini";
?>
</head>
<body>
<div id="div_centro" >
  <div id="FWTableContainer474730518" >
    <table width="787" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
      <!-- fwtable fwsrc="" fwpage="Page 1" fwbase="layout_carhmo copy.png" fwstyle="Dreamweaver" fwdocid = "474730518" fwnested="0" -->
      <tr>
        <td width="196"><img src="images/spacer.gif" width="196" height="1" border="0" alt="" /></td>
        <td width="197"><img src="images/spacer.gif" width="197" height="1" border="0" alt="" /></td>
        <td width="2"><img src="images/spacer.gif" width="2" height="1" border="0" alt="" /></td>
        <td width="158"><img src="images/spacer.gif" width="158" height="1" border="0" alt="" /></td>
        <td width="37"><img src="images/spacer.gif" width="37" height="1" border="0" alt="" /></td>
        <td width="2"><img src="images/spacer.gif" width="2" height="1" border="0" alt="" /></td>
        <td width="7"><img src="images/spacer.gif" width="7" height="1" border="0" alt="" /></td>
        <td width="174"><img src="images/spacer.gif" width="174" height="1" border="0" alt="" /></td>
        <td width="14"><img src="images/spacer.gif" width="14" height="1" border="0" alt="" /></td>
        <td width="1"><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
      </tr>
      <tr>
        <td colspan="10"><img name="a_01" src="images/a_01.png" width="788" height="16" border="0" id="a_01" alt="" /></td>
      </tr>
      <tr>
        <td rowspan="2" colspan="4"><a href="index.php"><img name="b_02" src="images/b_02.png" width="553" height="123" border="0" id="b_02" alt="" /></a></td>
        <td colspan="4">
       			 <?php require_once 'modulos/login/login.php'; ?>
        </td>
        <td rowspan="2" colspan="2"><img name="d_04" src="images/d_04.png" width="15" height="123" border="0" id="d_04" alt="" /></td>
      </tr>
      <tr>
        <td colspan="4" valign="bottom"><img name="e_05" src="images/e_05.png" width="220" height="45" border="0" id="e_05" alt="" /></td>
      </tr>
      <tr>
        <td colspan="10"><img name="f_06" src="images/f_06.png" width="788" height="18" border="0" id="f_06" alt="" /></td>
      </tr>
      <tr>
        <td colspan="10"> 
       
<?php require_once 'menu.php'; ?>
        
        </td>
      </tr>
      <tr>
        <td colspan="10"><img name="o_15" src="images/o_15.png" width="788" height="4" border="0" id="o_15" alt="" /></td>
      </tr>
      <tr>
        <td colspan="5"><img name="p_16" src="images/p_16.png" width="590" height="26" border="0" id="p_16" alt="" /></td>
        <td colspan="2"><img name="q_17" src="images/q_17.png" width="9" height="26" border="0" id="q_17" alt="" /></td>
        
        
        
        <td colspan="3">&nbsp;</td>
      </tr>
      <tr>
        <td colspan="5" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="3">
          <tr>
            <td width="100%" align="left" valign="top"><p>&nbsp;</p></td>
          </tr>
          <tr>
            <td align="left" valign="top">
            
            
<table width="98%" cellpadding="3" cellspacing="0" border="0">

            <?php 
			
		$where = ' WHERE 1=1 ';	
		if( $_GET[md5('actionRegistro')] != '' ){
			$where .= ' AND md5(co_vaga) = \''.$_GET[md5('actionRegistro')].'\' ';
		}else{
			echo "<script>alert('Selecione uma vaga para ver os detalhes.');window.location.href='".$_SERVER['HTTP_REFERER']."';</script>";	
		}


		$sql = "SELECT DISTINCT 
		  tbl_cadastro.no_nome_empresa,
		  tbl_cadastro.no_email,
		  tbl_cadastro.no_email_contato,
		  tbl_cadastro.no_endereco,
		  tbl_cadastro.no_numero,
		  tbl_cadastro.no_complemento,
		  tbl_cadastro.no_bairro,
		  tbl_cadastro.no_cidade,
		  tbl_cadastro.no_uf,
		  tbl_cadastro.nu_telefone,
		  tbl_cadastro.nu_celular,
		  tbl_cadastro.nu_comercial,
		  tbl_cadastro.nu_cep,
		  tbl_vaga.co_vaga,
		  tbl_vaga.co_cadastro,
		  tbl_area_profissional.no_area_profissional,
		  tbl_categoria_profissional.no_categoria_profissional,
		  tbl_faixa_salarial.no_faixa_salarial,
		  tbl_hierarquia.no_hierarquia,
		  tbl_vaga.sg_uf,
		  tbl_vaga.no_vaga,
		  tbl_vaga.ds_vaga,
		  tbl_vaga.no_salario,
		  tbl_vaga.no_email_contato,
		  tbl_vaga.st_mostra_empresa,
		  tbl_vaga.dt_cadastro,
		  tbl_vaga.st_status
		FROM
		  tbl_cadastro
		  INNER JOIN tbl_vaga ON (tbl_cadastro.co_codigo = tbl_vaga.co_cadastro)
		  INNER JOIN tbl_area_profissional ON (tbl_vaga.co_area_profissional = tbl_area_profissional.co_area_profissional)
		  INNER JOIN tbl_categoria_profissional ON (tbl_vaga.co_categoria_profissional = tbl_categoria_profissional.co_categoria_profissional)
		  INNER JOIN tbl_faixa_salarial ON (tbl_vaga.co_faixa_salarial = tbl_faixa_salarial.co_faixa_salarial)
		  INNER JOIN tbl_hierarquia ON (tbl_vaga.co_hierarquia = tbl_hierarquia.co_hierarquia)  $where ";

		$objRegistro  =  $objConn->Execute( $sql );
		
		if( $objError->semErros() && $objRegistro->_numOfRows > 0)
		{
		    
			while( !$objRegistro->EOF ) { 
					
			
?>
            <tr>
              <td width="100%" align="left" valign="middle" bgcolor="#F8F8F8" ><div style="font-size:14px;color:#333333"> <strong><?php echo $objRegistro->fields['no_vaga']; ?></strong></div>
                <strong><br />
                Data de Cadastro</strong>: <?php echo $objRegistro->fields['dt_cadastro2']; ?><br />
              </td>
  </tr>
            <tr>
              <td width="100%" align="right" valign="middle" bgcolor="#ffffff"><a href="detalhes_vagas.php"><img src="images/icones/mais.png" width="119" height="34" border="0" /></a>                <hr style="height:1px" /></td>
  </tr>
            <?php $objRegistro->MoveNext();
			}
		} else{
	?>
            <tr>
              <td width="100%" align="left" valign="middle" bgcolor="#F8F8F8">Nenhuma vaga encontrada.</td>
  </tr>
            <?php }?>
            </table>            
            
            
</td>
          </tr>
          <tr>
            <td align="left" valign="top"></td>
          </tr>
        </table></td>
        <td colspan="2" background="images/q_17.png">&nbsp;</td>
        <td colspan="3" valign="top" bgcolor="#DEE3E9"><table width="100%" border="0" cellpadding="4" cellspacing="0" bgcolor="#FFFFFF">
            <tr>
              <td><?php require_once 'modulos/lateral/leftMenu.php'; ?></td>
            </tr>
            <tr>
              <td>&nbsp;</td>
            </tr>
          </table>
          <img src="images/u_21.png" alt="" name="u_21" width="189" height="385" border="0" align="bottom" id="u_21" style="vertical-align:bottom" /></td>
      </tr>
    </table>
</div>
</div>
<div id="div_centro2" style="margin-top:0px" > 
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>© Copyright 2011. Todos os direitos reservados. <a href="http://www.voitech.com.br" target="_blank"><img src="images/desenvolvido.png" alt="VOITECH SISTEMAS" width="150" height="30" border="0" align="absmiddle" longdesc="http://www.voitech.com.br" /></a></p>
</div>
</body>
</html>
